{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 204,
   "metadata": {},
   "outputs": [],
   "source": [
    "#数据矩阵处理\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 205,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 统计训练集中有多少不同的用户/不同的events\n",
    "uniqueUsers = set()\n",
    "uniqueEvents = set()\n",
    "\n",
    "for filename in [\"train.csv\", \"test.csv\"]:\n",
    "    f = open(filename, 'r',encoding=\"utf-8\") \n",
    "    \n",
    "    #忽略第一行（列名字）,每行按逗号分隔\n",
    "    f.readline().strip().split(\",\")\n",
    "    #print(f)\n",
    "    for line in f:\n",
    "        #对每条记录\n",
    "        cols = line.strip().split(\",\") \n",
    "        #print(line)\n",
    "        uniqueUsers.add(cols[0])   #第一列为用户ID\n",
    "        uniqueEvents.add(cols[1])   #第二列为活动ID\n",
    "        \n",
    "        #eventsForUser[cols[0]].add(cols[1])    #该用户参加了这个活动\n",
    "        #usersForEvent[cols[1]].add(cols[0])    #该活动被用户参加\n",
    "    f.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 206,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "number of uniqueUsers :3391\n",
      "number of uniqueEvents :13418\n"
     ]
    }
   ],
   "source": [
    "#打印用户数及活动数\n",
    "n_uniqueUsers = len(uniqueUsers)\n",
    "n_uniqueEvents = len(uniqueEvents)\n",
    "\n",
    "print(\"number of uniqueUsers :%d\" % n_uniqueUsers)\n",
    "print(\"number of uniqueEvents :%d\" % n_uniqueEvents)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "明显看到训练集和测试集中出现的用户数目和事件数目远小于users.csv出现的用户数和events.csv出现的事件数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [],
   "source": [
    "events=pd.read_csv(\"events.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>start_time</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "      <th>zip</th>\n",
       "      <th>country</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>c_1</th>\n",
       "      <th>...</th>\n",
       "      <th>c_92</th>\n",
       "      <th>c_93</th>\n",
       "      <th>c_94</th>\n",
       "      <th>c_95</th>\n",
       "      <th>c_96</th>\n",
       "      <th>c_97</th>\n",
       "      <th>c_98</th>\n",
       "      <th>c_99</th>\n",
       "      <th>c_100</th>\n",
       "      <th>c_other</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>684921758</td>\n",
       "      <td>3647864012</td>\n",
       "      <td>2012-10-31T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>244999119</td>\n",
       "      <td>3476440521</td>\n",
       "      <td>2012-11-03T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3928440935</td>\n",
       "      <td>517514445</td>\n",
       "      <td>2012-11-05T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2582345152</td>\n",
       "      <td>781585781</td>\n",
       "      <td>2012-10-30T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1051165850</td>\n",
       "      <td>1016098580</td>\n",
       "      <td>2012-09-27T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 110 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     event_id     user_id                start_time city state  zip country  \\\n",
       "0   684921758  3647864012  2012-10-31T00:00:00.001Z  NaN   NaN  NaN     NaN   \n",
       "1   244999119  3476440521  2012-11-03T00:00:00.001Z  NaN   NaN  NaN     NaN   \n",
       "2  3928440935   517514445  2012-11-05T00:00:00.001Z  NaN   NaN  NaN     NaN   \n",
       "3  2582345152   781585781  2012-10-30T00:00:00.001Z  NaN   NaN  NaN     NaN   \n",
       "4  1051165850  1016098580  2012-09-27T00:00:00.001Z  NaN   NaN  NaN     NaN   \n",
       "\n",
       "   lat  lng  c_1   ...     c_92  c_93  c_94  c_95  c_96  c_97  c_98  c_99  \\\n",
       "0  NaN  NaN    2   ...        0     1     0     0     0     0     0     0   \n",
       "1  NaN  NaN    2   ...        0     0     0     0     0     0     0     0   \n",
       "2  NaN  NaN    0   ...        0     0     0     0     0     0     0     0   \n",
       "3  NaN  NaN    1   ...        0     0     0     0     0     0     0     0   \n",
       "4  NaN  NaN    1   ...        0     0     0     0     0     0     0     0   \n",
       "\n",
       "   c_100  c_other  \n",
       "0      0        9  \n",
       "1      0        7  \n",
       "2      0       12  \n",
       "3      0        8  \n",
       "4      0        9  \n",
       "\n",
       "[5 rows x 110 columns]"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "events.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1845469953', '715927047']"
      ]
     },
     "execution_count": 234,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "uniqueEvents=list(uniqueEvents) #训练集和测试集都出现的活动列表\n",
    "# uniqueEvents[0:2]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 242,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>start_time</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "      <th>zip</th>\n",
       "      <th>country</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>c_1</th>\n",
       "      <th>...</th>\n",
       "      <th>c_92</th>\n",
       "      <th>c_93</th>\n",
       "      <th>c_94</th>\n",
       "      <th>c_95</th>\n",
       "      <th>c_96</th>\n",
       "      <th>c_97</th>\n",
       "      <th>c_98</th>\n",
       "      <th>c_99</th>\n",
       "      <th>c_100</th>\n",
       "      <th>c_other</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>820597</th>\n",
       "      <td>1845469953</td>\n",
       "      <td>2522958388</td>\n",
       "      <td>2012-08-18T03:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651267</th>\n",
       "      <td>715927047</td>\n",
       "      <td>2897297904</td>\n",
       "      <td>2012-09-30T01:00:00.003Z</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.752</td>\n",
       "      <td>-122.201</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1806667</th>\n",
       "      <td>1129492416</td>\n",
       "      <td>3585990576</td>\n",
       "      <td>2012-11-23T05:45:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96797</th>\n",
       "      <td>2351559782</td>\n",
       "      <td>3258059419</td>\n",
       "      <td>2012-10-27T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3059704</th>\n",
       "      <td>741936389</td>\n",
       "      <td>3930427944</td>\n",
       "      <td>2012-10-31T10:00:00.003Z</td>\n",
       "      <td>Malang</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>-7.983</td>\n",
       "      <td>112.631</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2307609</th>\n",
       "      <td>1948220396</td>\n",
       "      <td>4227306561</td>\n",
       "      <td>2012-11-04T00:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21893</th>\n",
       "      <td>34564349</td>\n",
       "      <td>1692956626</td>\n",
       "      <td>2012-08-30T14:00:00.003Z</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.703</td>\n",
       "      <td>-79.637</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1742879</th>\n",
       "      <td>4015174764</td>\n",
       "      <td>4022520287</td>\n",
       "      <td>2012-10-23T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2260169</th>\n",
       "      <td>1946764368</td>\n",
       "      <td>1325201873</td>\n",
       "      <td>2012-11-03T00:00:00.003Z</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.753</td>\n",
       "      <td>-122.411</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2297572</th>\n",
       "      <td>1819998447</td>\n",
       "      <td>2552531914</td>\n",
       "      <td>2012-11-21T04:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1138234</th>\n",
       "      <td>2826046335</td>\n",
       "      <td>436803290</td>\n",
       "      <td>2012-09-30T00:00:00.001Z</td>\n",
       "      <td>Anaheim</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.839</td>\n",
       "      <td>-117.915</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>517</th>\n",
       "      <td>3964060639</td>\n",
       "      <td>2338866445</td>\n",
       "      <td>2012-10-30T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2565505</th>\n",
       "      <td>2383453267</td>\n",
       "      <td>1909585056</td>\n",
       "      <td>2012-11-05T05:30:00.003Z</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>India</td>\n",
       "      <td>18.980</td>\n",
       "      <td>72.820</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2484147</th>\n",
       "      <td>3950353223</td>\n",
       "      <td>3612176534</td>\n",
       "      <td>2012-10-28T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1569</th>\n",
       "      <td>1824198418</td>\n",
       "      <td>1765760625</td>\n",
       "      <td>2012-11-09T04:00:00.003Z</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>34.008</td>\n",
       "      <td>-118.335</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2280673</th>\n",
       "      <td>533036818</td>\n",
       "      <td>212960004</td>\n",
       "      <td>2013-01-27T02:00:00.003Z</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>CA</td>\n",
       "      <td>90021</td>\n",
       "      <td>United States</td>\n",
       "      <td>34.029</td>\n",
       "      <td>-118.240</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3091222</th>\n",
       "      <td>3127693636</td>\n",
       "      <td>932476685</td>\n",
       "      <td>2012-09-23T02:00:00.003Z</td>\n",
       "      <td>Oakville</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.488</td>\n",
       "      <td>-79.719</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>537231</th>\n",
       "      <td>326944617</td>\n",
       "      <td>1332974458</td>\n",
       "      <td>2012-11-29T17:49:11.002Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>653</th>\n",
       "      <td>1112861675</td>\n",
       "      <td>1424862274</td>\n",
       "      <td>2012-10-30T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2797007</th>\n",
       "      <td>1446660181</td>\n",
       "      <td>3255369878</td>\n",
       "      <td>2012-12-08T17:00:00.003Z</td>\n",
       "      <td>Doswell</td>\n",
       "      <td>VA</td>\n",
       "      <td>23047</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.851</td>\n",
       "      <td>-77.424</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1965107</th>\n",
       "      <td>4234683959</td>\n",
       "      <td>1721067031</td>\n",
       "      <td>2012-10-11T00:00:00.001Z</td>\n",
       "      <td>Niagara Falls</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.092</td>\n",
       "      <td>-79.077</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444107</th>\n",
       "      <td>2221249291</td>\n",
       "      <td>3912862329</td>\n",
       "      <td>2012-09-29T02:00:00.003Z</td>\n",
       "      <td>Riverdale</td>\n",
       "      <td>GA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.553</td>\n",
       "      <td>-84.465</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>352</th>\n",
       "      <td>3022809854</td>\n",
       "      <td>3428829795</td>\n",
       "      <td>2012-08-31T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>713690</th>\n",
       "      <td>1222056986</td>\n",
       "      <td>3293416293</td>\n",
       "      <td>2012-11-15T01:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3059880</th>\n",
       "      <td>2525317671</td>\n",
       "      <td>215831159</td>\n",
       "      <td>2012-08-08T04:00:00.000Z</td>\n",
       "      <td>Fullerton</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.870</td>\n",
       "      <td>-117.923</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>473</th>\n",
       "      <td>918116457</td>\n",
       "      <td>4193237938</td>\n",
       "      <td>2012-10-31T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>740244</th>\n",
       "      <td>1672546494</td>\n",
       "      <td>2785723175</td>\n",
       "      <td>2012-11-25T06:00:00.003Z</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94110</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.756</td>\n",
       "      <td>-122.419</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>789309</th>\n",
       "      <td>1050017180</td>\n",
       "      <td>2744017856</td>\n",
       "      <td>2012-09-29T15:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2645782</th>\n",
       "      <td>1286933492</td>\n",
       "      <td>1459655831</td>\n",
       "      <td>2012-09-26T00:00:00.001Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.662</td>\n",
       "      <td>-79.340</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2235157</th>\n",
       "      <td>1741021722</td>\n",
       "      <td>1357476826</td>\n",
       "      <td>2012-08-31T23:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.983</td>\n",
       "      <td>-79.250</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>620931168</td>\n",
       "      <td>3912727517</td>\n",
       "      <td>2012-10-03T21:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2046647</th>\n",
       "      <td>2135167144</td>\n",
       "      <td>2847881957</td>\n",
       "      <td>2012-10-21T02:00:00.003Z</td>\n",
       "      <td>Anaheim</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.856</td>\n",
       "      <td>-117.863</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2261711</th>\n",
       "      <td>4092803548</td>\n",
       "      <td>1818198294</td>\n",
       "      <td>2012-10-27T19:00:00.003Z</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Finland</td>\n",
       "      <td>60.163</td>\n",
       "      <td>24.941</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2176466</th>\n",
       "      <td>3851706723</td>\n",
       "      <td>4022520287</td>\n",
       "      <td>2012-10-10T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1592945</th>\n",
       "      <td>4283392525</td>\n",
       "      <td>1272638968</td>\n",
       "      <td>2012-10-31T03:00:00.003Z</td>\n",
       "      <td>Albuquerque</td>\n",
       "      <td>NM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>35.079</td>\n",
       "      <td>-106.599</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2938988</th>\n",
       "      <td>3938234624</td>\n",
       "      <td>3155750308</td>\n",
       "      <td>2012-11-30T19:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1165000</th>\n",
       "      <td>3696272381</td>\n",
       "      <td>2511987302</td>\n",
       "      <td>2012-11-02T12:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2565174</th>\n",
       "      <td>4153011100</td>\n",
       "      <td>902911007</td>\n",
       "      <td>2012-09-23T04:30:00.003Z</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>AZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.449</td>\n",
       "      <td>-112.072</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2949039</th>\n",
       "      <td>3616152803</td>\n",
       "      <td>2309901072</td>\n",
       "      <td>2012-11-18T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1257322</th>\n",
       "      <td>806696202</td>\n",
       "      <td>2376596313</td>\n",
       "      <td>2012-12-01T19:00:00.003Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>M6G 1M4</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.662</td>\n",
       "      <td>-79.425</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3099040</th>\n",
       "      <td>2579139880</td>\n",
       "      <td>3122709116</td>\n",
       "      <td>2012-11-30T14:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.167</td>\n",
       "      <td>101.651</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1313544</th>\n",
       "      <td>3483869180</td>\n",
       "      <td>3636323848</td>\n",
       "      <td>2012-11-02T11:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>617836</th>\n",
       "      <td>3327512314</td>\n",
       "      <td>337595881</td>\n",
       "      <td>2012-08-11T17:00:00.000Z</td>\n",
       "      <td>Amsterdam</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>52.390</td>\n",
       "      <td>4.825</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1466288</th>\n",
       "      <td>3392687713</td>\n",
       "      <td>2942481107</td>\n",
       "      <td>2012-11-22T02:00:00.003Z</td>\n",
       "      <td>San Antonio</td>\n",
       "      <td>TX</td>\n",
       "      <td>78212</td>\n",
       "      <td>United States</td>\n",
       "      <td>29.455</td>\n",
       "      <td>-98.500</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2101283</th>\n",
       "      <td>2175249529</td>\n",
       "      <td>2758197166</td>\n",
       "      <td>2012-09-23T02:00:00.003Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.657</td>\n",
       "      <td>-79.403</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>504</th>\n",
       "      <td>376593949</td>\n",
       "      <td>415464198</td>\n",
       "      <td>2012-10-12T00:00:00.002Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1408539</th>\n",
       "      <td>3669346949</td>\n",
       "      <td>3414348124</td>\n",
       "      <td>2012-10-07T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661630</th>\n",
       "      <td>2803195749</td>\n",
       "      <td>455278736</td>\n",
       "      <td>2012-10-31T00:00:00.001Z</td>\n",
       "      <td>Banyumas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>-7.444</td>\n",
       "      <td>109.244</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>567674</th>\n",
       "      <td>1064284965</td>\n",
       "      <td>275013371</td>\n",
       "      <td>2012-10-24T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-7.284</td>\n",
       "      <td>112.764</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2698825</th>\n",
       "      <td>2588804869</td>\n",
       "      <td>3578405258</td>\n",
       "      <td>2012-10-31T19:00:00.003Z</td>\n",
       "      <td>Tirana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Albania</td>\n",
       "      <td>41.338</td>\n",
       "      <td>19.785</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>505</th>\n",
       "      <td>156353771</td>\n",
       "      <td>2315928166</td>\n",
       "      <td>2012-10-28T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2074445</th>\n",
       "      <td>2200684348</td>\n",
       "      <td>1507135490</td>\n",
       "      <td>2012-12-07T03:00:00.003Z</td>\n",
       "      <td>Paterson</td>\n",
       "      <td>NJ</td>\n",
       "      <td>07501-3626</td>\n",
       "      <td>United States</td>\n",
       "      <td>40.909</td>\n",
       "      <td>-74.159</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2589902</th>\n",
       "      <td>3720632668</td>\n",
       "      <td>3899589477</td>\n",
       "      <td>2012-11-17T04:30:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.235</td>\n",
       "      <td>-118.473</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>953685</th>\n",
       "      <td>423805107</td>\n",
       "      <td>2525044672</td>\n",
       "      <td>2012-10-01T15:00:00.003Z</td>\n",
       "      <td>Granby</td>\n",
       "      <td>QC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>45.402</td>\n",
       "      <td>-72.731</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>573875</th>\n",
       "      <td>3822409571</td>\n",
       "      <td>202776250</td>\n",
       "      <td>2012-08-02T19:00:00.000Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.653</td>\n",
       "      <td>-79.401</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>511625</th>\n",
       "      <td>1699116640</td>\n",
       "      <td>3032684355</td>\n",
       "      <td>2012-11-21T00:00:00.003Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>M6J 1B8</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.645</td>\n",
       "      <td>-79.417</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>2700038507</td>\n",
       "      <td>1437095076</td>\n",
       "      <td>2012-10-31T00:00:00.001Z</td>\n",
       "      <td>Iztapalapa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>19.442</td>\n",
       "      <td>-99.138</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2994052</th>\n",
       "      <td>2522610844</td>\n",
       "      <td>741828421</td>\n",
       "      <td>2012-10-19T01:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2863170</th>\n",
       "      <td>1429241116</td>\n",
       "      <td>4044300809</td>\n",
       "      <td>2012-08-10T02:30:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.060</td>\n",
       "      <td>-98.280</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>359</th>\n",
       "      <td>1973916091</td>\n",
       "      <td>2525805561</td>\n",
       "      <td>2012-10-30T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13418 rows × 110 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           event_id     user_id                start_time           city  \\\n",
       "820597   1845469953  2522958388  2012-08-18T03:00:00.003Z            NaN   \n",
       "1651267   715927047  2897297904  2012-09-30T01:00:00.003Z        Oakland   \n",
       "1806667  1129492416  3585990576  2012-11-23T05:45:00.003Z            NaN   \n",
       "96797    2351559782  3258059419  2012-10-27T00:00:00.001Z            NaN   \n",
       "3059704   741936389  3930427944  2012-10-31T10:00:00.003Z         Malang   \n",
       "2307609  1948220396  4227306561  2012-11-04T00:00:00.003Z            NaN   \n",
       "21893      34564349  1692956626  2012-08-30T14:00:00.003Z    Mississauga   \n",
       "1742879  4015174764  4022520287  2012-10-23T00:00:00.001Z            NaN   \n",
       "2260169  1946764368  1325201873  2012-11-03T00:00:00.003Z  San Francisco   \n",
       "2297572  1819998447  2552531914  2012-11-21T04:00:00.003Z            NaN   \n",
       "1138234  2826046335   436803290  2012-09-30T00:00:00.001Z        Anaheim   \n",
       "517      3964060639  2338866445  2012-10-30T00:00:00.001Z            NaN   \n",
       "2565505  2383453267  1909585056  2012-11-05T05:30:00.003Z         Mumbai   \n",
       "2484147  3950353223  3612176534  2012-10-28T00:00:00.001Z            NaN   \n",
       "1569     1824198418  1765760625  2012-11-09T04:00:00.003Z    Los Angeles   \n",
       "2280673   533036818   212960004  2013-01-27T02:00:00.003Z    Los Angeles   \n",
       "3091222  3127693636   932476685  2012-09-23T02:00:00.003Z       Oakville   \n",
       "537231    326944617  1332974458  2012-11-29T17:49:11.002Z            NaN   \n",
       "653      1112861675  1424862274  2012-10-30T00:00:00.001Z            NaN   \n",
       "2797007  1446660181  3255369878  2012-12-08T17:00:00.003Z        Doswell   \n",
       "1965107  4234683959  1721067031  2012-10-11T00:00:00.001Z  Niagara Falls   \n",
       "444107   2221249291  3912862329  2012-09-29T02:00:00.003Z      Riverdale   \n",
       "352      3022809854  3428829795  2012-08-31T00:00:00.001Z            NaN   \n",
       "713690   1222056986  3293416293  2012-11-15T01:00:00.003Z            NaN   \n",
       "3059880  2525317671   215831159  2012-08-08T04:00:00.000Z      Fullerton   \n",
       "473       918116457  4193237938  2012-10-31T00:00:00.001Z            NaN   \n",
       "740244   1672546494  2785723175  2012-11-25T06:00:00.003Z  San Francisco   \n",
       "789309   1050017180  2744017856  2012-09-29T15:00:00.003Z            NaN   \n",
       "2645782  1286933492  1459655831  2012-09-26T00:00:00.001Z        Toronto   \n",
       "2235157  1741021722  1357476826  2012-08-31T23:00:00.003Z            NaN   \n",
       "...             ...         ...                       ...            ...   \n",
       "183       620931168  3912727517  2012-10-03T21:00:00.003Z            NaN   \n",
       "2046647  2135167144  2847881957  2012-10-21T02:00:00.003Z        Anaheim   \n",
       "2261711  4092803548  1818198294  2012-10-27T19:00:00.003Z       Helsinki   \n",
       "2176466  3851706723  4022520287  2012-10-10T00:00:00.001Z            NaN   \n",
       "1592945  4283392525  1272638968  2012-10-31T03:00:00.003Z    Albuquerque   \n",
       "2938988  3938234624  3155750308  2012-11-30T19:00:00.003Z            NaN   \n",
       "1165000  3696272381  2511987302  2012-11-02T12:00:00.003Z            NaN   \n",
       "2565174  4153011100   902911007  2012-09-23T04:30:00.003Z        Phoenix   \n",
       "2949039  3616152803  2309901072  2012-11-18T00:00:00.001Z            NaN   \n",
       "1257322   806696202  2376596313  2012-12-01T19:00:00.003Z        Toronto   \n",
       "3099040  2579139880  3122709116  2012-11-30T14:00:00.003Z            NaN   \n",
       "1313544  3483869180  3636323848  2012-11-02T11:00:00.003Z            NaN   \n",
       "617836   3327512314   337595881  2012-08-11T17:00:00.000Z      Amsterdam   \n",
       "1466288  3392687713  2942481107  2012-11-22T02:00:00.003Z    San Antonio   \n",
       "2101283  2175249529  2758197166  2012-09-23T02:00:00.003Z        Toronto   \n",
       "504       376593949   415464198  2012-10-12T00:00:00.002Z            NaN   \n",
       "1408539  3669346949  3414348124  2012-10-07T00:00:00.001Z            NaN   \n",
       "1661630  2803195749   455278736  2012-10-31T00:00:00.001Z       Banyumas   \n",
       "567674   1064284965   275013371  2012-10-24T00:00:00.001Z            NaN   \n",
       "2698825  2588804869  3578405258  2012-10-31T19:00:00.003Z         Tirana   \n",
       "505       156353771  2315928166  2012-10-28T00:00:00.001Z            NaN   \n",
       "2074445  2200684348  1507135490  2012-12-07T03:00:00.003Z       Paterson   \n",
       "2589902  3720632668  3899589477  2012-11-17T04:30:00.003Z            NaN   \n",
       "953685    423805107  2525044672  2012-10-01T15:00:00.003Z         Granby   \n",
       "573875   3822409571   202776250  2012-08-02T19:00:00.000Z        Toronto   \n",
       "511625   1699116640  3032684355  2012-11-21T00:00:00.003Z        Toronto   \n",
       "405      2700038507  1437095076  2012-10-31T00:00:00.001Z     Iztapalapa   \n",
       "2994052  2522610844   741828421  2012-10-19T01:00:00.003Z            NaN   \n",
       "2863170  1429241116  4044300809  2012-08-10T02:30:00.000Z            NaN   \n",
       "359      1973916091  2525805561  2012-10-30T00:00:00.001Z            NaN   \n",
       "\n",
       "        state         zip        country     lat      lng  c_1   ...     c_92  \\\n",
       "820597    NaN         NaN            NaN     NaN      NaN    3   ...        0   \n",
       "1651267    CA         NaN  United States  37.752 -122.201   10   ...        0   \n",
       "1806667   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "96797     NaN         NaN            NaN     NaN      NaN    1   ...        0   \n",
       "3059704   NaN         NaN      Indonesia  -7.983  112.631    0   ...        0   \n",
       "2307609   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "21893      ON         NaN         Canada  43.703  -79.637    5   ...        0   \n",
       "1742879   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "2260169    CA         NaN  United States  37.753 -122.411    4   ...        0   \n",
       "2297572   NaN         NaN            NaN     NaN      NaN    1   ...        0   \n",
       "1138234    CA         NaN  United States  33.839 -117.915    0   ...        0   \n",
       "517       NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "2565505   NaN         NaN          India  18.980   72.820    0   ...        0   \n",
       "2484147   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "1569       CA         NaN  United States  34.008 -118.335   11   ...        0   \n",
       "2280673    CA       90021  United States  34.029 -118.240   16   ...        0   \n",
       "3091222    ON         NaN         Canada  43.488  -79.719    3   ...        0   \n",
       "537231    NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "653       NaN         NaN            NaN     NaN      NaN    1   ...        0   \n",
       "2797007    VA       23047  United States  37.851  -77.424    4   ...        0   \n",
       "1965107    ON         NaN         Canada  43.092  -79.077    1   ...        0   \n",
       "444107     GA         NaN  United States  33.553  -84.465    2   ...        0   \n",
       "352       NaN         NaN            NaN     NaN      NaN    1   ...        0   \n",
       "713690    NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "3059880    CA         NaN  United States  33.870 -117.923    4   ...        0   \n",
       "473       NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "740244     CA       94110  United States  37.756 -122.419    1   ...        0   \n",
       "789309    NaN         NaN            NaN     NaN      NaN    8   ...        0   \n",
       "2645782    ON         NaN         Canada  43.662  -79.340    0   ...        0   \n",
       "2235157   NaN         NaN            NaN  42.983  -79.250    0   ...        0   \n",
       "...       ...         ...            ...     ...      ...  ...   ...      ...   \n",
       "183       NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "2046647    CA         NaN  United States  33.856 -117.863    2   ...        0   \n",
       "2261711   NaN         NaN        Finland  60.163   24.941    4   ...        0   \n",
       "2176466   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "1592945    NM         NaN  United States  35.079 -106.599    3   ...        1   \n",
       "2938988   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "1165000   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "2565174    AZ         NaN  United States  33.449 -112.072    1   ...        0   \n",
       "2949039   NaN         NaN            NaN     NaN      NaN    1   ...        0   \n",
       "1257322    ON     M6G 1M4         Canada  43.662  -79.425    7   ...        0   \n",
       "3099040   NaN         NaN            NaN   3.167  101.651    5   ...        0   \n",
       "1313544   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "617836    NaN         NaN    Netherlands  52.390    4.825    4   ...        0   \n",
       "1466288    TX       78212  United States  29.455  -98.500    0   ...        0   \n",
       "2101283    ON         NaN         Canada  43.657  -79.403    0   ...        0   \n",
       "504       NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "1408539   NaN         NaN            NaN     NaN      NaN    4   ...        1   \n",
       "1661630   NaN         NaN      Indonesia  -7.444  109.244    0   ...        0   \n",
       "567674    NaN         NaN            NaN  -7.284  112.764    0   ...        0   \n",
       "2698825   NaN         NaN        Albania  41.338   19.785    0   ...        0   \n",
       "505       NaN         NaN            NaN     NaN      NaN    1   ...        0   \n",
       "2074445    NJ  07501-3626  United States  40.909  -74.159    2   ...        0   \n",
       "2589902   NaN         NaN            NaN  34.235 -118.473    2   ...        0   \n",
       "953685     QC         NaN         Canada  45.402  -72.731    3   ...        1   \n",
       "573875     ON         NaN         Canada  43.653  -79.401    7   ...        1   \n",
       "511625     ON     M6J 1B8         Canada  43.645  -79.417    4   ...        0   \n",
       "405       NaN         NaN         Mexico  19.442  -99.138    0   ...        0   \n",
       "2994052   NaN         NaN            NaN     NaN      NaN    0   ...        0   \n",
       "2863170   NaN         NaN            NaN  19.060  -98.280    0   ...        0   \n",
       "359       NaN         NaN            NaN     NaN      NaN    1   ...        0   \n",
       "\n",
       "         c_93  c_94  c_95  c_96  c_97  c_98  c_99  c_100  c_other  \n",
       "820597      0     0     1     0     0     0     0      0       54  \n",
       "1651267     0     2     0     1     0     0     0      0       86  \n",
       "1806667     0     0     0     0     0     0     0      0       35  \n",
       "96797       0     0     0     0     0     0     0      0       13  \n",
       "3059704     0     0     0     0     0     0     0      0      253  \n",
       "2307609     0     0     0     0     0     0     0      0        5  \n",
       "21893       0     1     1     0     0     0     0      0      128  \n",
       "1742879     0     0     0     0     0     0     0      0       14  \n",
       "2260169     0     0     0     1     0     0     0      0       52  \n",
       "2297572     0     0     0     0     0     0     0      0       17  \n",
       "1138234     0     0     0     0     0     0     0      0       42  \n",
       "517         0     1     0     0     1     0     0      0       48  \n",
       "2565505     0     0     0     0     1     0     0      0       16  \n",
       "2484147     0     0     0     0     0     0     0      0       96  \n",
       "1569        0     1     0     1     1     4     0      0      304  \n",
       "2280673     0     0     0     3     1     0     0      0      336  \n",
       "3091222     1     0     0     0     0     0     0      0       51  \n",
       "537231      1     0     0     1     0     0     0      0       27  \n",
       "653         0     0     0     0     0     0     0      0        9  \n",
       "2797007     0     0     0     0     0     0     0      0       57  \n",
       "1965107     0     0     0     0     1     0     0      0       39  \n",
       "444107      0     0     0     0     0     0     0      0       54  \n",
       "352         0     0     0     0     0     0     0      0        9  \n",
       "713690      0     0     0     0     0     0     0      0        9  \n",
       "3059880     0     0     0     0     0     0     0      0       63  \n",
       "473         0     0     0     0     0     0     0      0        2  \n",
       "740244      0     0     0     0     0     0     0      0       28  \n",
       "789309      0     0     0     0     0     0     0      0       67  \n",
       "2645782     0     0     0     0     0     0     0      0       21  \n",
       "2235157     0     0     0     0     0     0     0      0       10  \n",
       "...       ...   ...   ...   ...   ...   ...   ...    ...      ...  \n",
       "183         0     0     0     0     0     0     0      0       15  \n",
       "2046647     0     0     0     0     0     0     1      0       19  \n",
       "2261711     0     0     0     0     0     0     0      0       68  \n",
       "2176466     0     0     0     0     0     0     0      0       14  \n",
       "1592945     0     0     0     0     1     0     0      0       40  \n",
       "2938988     0     0     0     0     0     0     0      0       22  \n",
       "1165000     0     0     0     0     0     0     0      0       10  \n",
       "2565174     0     0     0     0     0     0     1      0      173  \n",
       "2949039     0     0     0     0     0     0     0      0        5  \n",
       "1257322     0     0     0     0     0     0     0      0       96  \n",
       "3099040     0     0     0     0     0     0     0      1       80  \n",
       "1313544     0     0     0     0     0     0     0      0        5  \n",
       "617836      0     0     0     0     0     0     0      0       33  \n",
       "1466288     0     0     0     0     0     0     0      0       38  \n",
       "2101283     0     0     0     0     0     0     0      0       40  \n",
       "504         0     0     0     0     0     0     0      0       10  \n",
       "1408539     0     0     0     0     0     0     0      0       34  \n",
       "1661630     0     0     0     0     0     0     0      0       75  \n",
       "567674      0     0     0     0     0     0     0      0      125  \n",
       "2698825     0     0     0     0     0     0     0      0       33  \n",
       "505         0     0     0     0     0     0     0      0        9  \n",
       "2074445     0     0     0     0     0     0     0      0       60  \n",
       "2589902     0     0     0     0     0     0     0      0       67  \n",
       "953685      0     0     0     0     0     0     0      0       39  \n",
       "573875      1     0     0     1     0     2     1      0       60  \n",
       "511625      1     0     0     0     0     1     0      1       63  \n",
       "405         0     0     0     0     0     0     0      0       43  \n",
       "2994052     0     0     0     0     0     0     0      1      177  \n",
       "2863170     0     0     0     0     0     0     0      0       29  \n",
       "359         1     0     0     0     0     0     0      0        9  \n",
       "\n",
       "[13418 rows x 110 columns]"
      ]
     },
     "execution_count": 242,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#筛选events中在训练集和测试集出现的活动con_events\n",
    "con_events=pd.DataFrame()\n",
    "for i in uniqueEvents:\n",
    "    con_event=events.loc[events.event_id==int(i)] #筛选\n",
    "    f=[con_events,con_event] \n",
    "    con_events=pd.concat(f) #合并\n",
    "con_events"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 257,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>event_id</th>\n",
       "      <th>user_id</th>\n",
       "      <th>start_time</th>\n",
       "      <th>city</th>\n",
       "      <th>state</th>\n",
       "      <th>zip</th>\n",
       "      <th>country</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>c_1</th>\n",
       "      <th>...</th>\n",
       "      <th>c_92</th>\n",
       "      <th>c_93</th>\n",
       "      <th>c_94</th>\n",
       "      <th>c_95</th>\n",
       "      <th>c_96</th>\n",
       "      <th>c_97</th>\n",
       "      <th>c_98</th>\n",
       "      <th>c_99</th>\n",
       "      <th>c_100</th>\n",
       "      <th>c_other</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1845469953</td>\n",
       "      <td>2522958388</td>\n",
       "      <td>2012-08-18T03:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>715927047</td>\n",
       "      <td>2897297904</td>\n",
       "      <td>2012-09-30T01:00:00.003Z</td>\n",
       "      <td>Oakland</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.752</td>\n",
       "      <td>-122.201</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1129492416</td>\n",
       "      <td>3585990576</td>\n",
       "      <td>2012-11-23T05:45:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2351559782</td>\n",
       "      <td>3258059419</td>\n",
       "      <td>2012-10-27T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>741936389</td>\n",
       "      <td>3930427944</td>\n",
       "      <td>2012-10-31T10:00:00.003Z</td>\n",
       "      <td>Malang</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>-7.983</td>\n",
       "      <td>112.631</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1948220396</td>\n",
       "      <td>4227306561</td>\n",
       "      <td>2012-11-04T00:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>34564349</td>\n",
       "      <td>1692956626</td>\n",
       "      <td>2012-08-30T14:00:00.003Z</td>\n",
       "      <td>Mississauga</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.703</td>\n",
       "      <td>-79.637</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4015174764</td>\n",
       "      <td>4022520287</td>\n",
       "      <td>2012-10-23T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1946764368</td>\n",
       "      <td>1325201873</td>\n",
       "      <td>2012-11-03T00:00:00.003Z</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.753</td>\n",
       "      <td>-122.411</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1819998447</td>\n",
       "      <td>2552531914</td>\n",
       "      <td>2012-11-21T04:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2826046335</td>\n",
       "      <td>436803290</td>\n",
       "      <td>2012-09-30T00:00:00.001Z</td>\n",
       "      <td>Anaheim</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.839</td>\n",
       "      <td>-117.915</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3964060639</td>\n",
       "      <td>2338866445</td>\n",
       "      <td>2012-10-30T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2383453267</td>\n",
       "      <td>1909585056</td>\n",
       "      <td>2012-11-05T05:30:00.003Z</td>\n",
       "      <td>Mumbai</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>India</td>\n",
       "      <td>18.980</td>\n",
       "      <td>72.820</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3950353223</td>\n",
       "      <td>3612176534</td>\n",
       "      <td>2012-10-28T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1824198418</td>\n",
       "      <td>1765760625</td>\n",
       "      <td>2012-11-09T04:00:00.003Z</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>34.008</td>\n",
       "      <td>-118.335</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>304</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>533036818</td>\n",
       "      <td>212960004</td>\n",
       "      <td>2013-01-27T02:00:00.003Z</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>CA</td>\n",
       "      <td>90021</td>\n",
       "      <td>United States</td>\n",
       "      <td>34.029</td>\n",
       "      <td>-118.240</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>3127693636</td>\n",
       "      <td>932476685</td>\n",
       "      <td>2012-09-23T02:00:00.003Z</td>\n",
       "      <td>Oakville</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.488</td>\n",
       "      <td>-79.719</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>326944617</td>\n",
       "      <td>1332974458</td>\n",
       "      <td>2012-11-29T17:49:11.002Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1112861675</td>\n",
       "      <td>1424862274</td>\n",
       "      <td>2012-10-30T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1446660181</td>\n",
       "      <td>3255369878</td>\n",
       "      <td>2012-12-08T17:00:00.003Z</td>\n",
       "      <td>Doswell</td>\n",
       "      <td>VA</td>\n",
       "      <td>23047</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.851</td>\n",
       "      <td>-77.424</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>4234683959</td>\n",
       "      <td>1721067031</td>\n",
       "      <td>2012-10-11T00:00:00.001Z</td>\n",
       "      <td>Niagara Falls</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.092</td>\n",
       "      <td>-79.077</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2221249291</td>\n",
       "      <td>3912862329</td>\n",
       "      <td>2012-09-29T02:00:00.003Z</td>\n",
       "      <td>Riverdale</td>\n",
       "      <td>GA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.553</td>\n",
       "      <td>-84.465</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>3022809854</td>\n",
       "      <td>3428829795</td>\n",
       "      <td>2012-08-31T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1222056986</td>\n",
       "      <td>3293416293</td>\n",
       "      <td>2012-11-15T01:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2525317671</td>\n",
       "      <td>215831159</td>\n",
       "      <td>2012-08-08T04:00:00.000Z</td>\n",
       "      <td>Fullerton</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.870</td>\n",
       "      <td>-117.923</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>918116457</td>\n",
       "      <td>4193237938</td>\n",
       "      <td>2012-10-31T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1672546494</td>\n",
       "      <td>2785723175</td>\n",
       "      <td>2012-11-25T06:00:00.003Z</td>\n",
       "      <td>San Francisco</td>\n",
       "      <td>CA</td>\n",
       "      <td>94110</td>\n",
       "      <td>United States</td>\n",
       "      <td>37.756</td>\n",
       "      <td>-122.419</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1050017180</td>\n",
       "      <td>2744017856</td>\n",
       "      <td>2012-09-29T15:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1286933492</td>\n",
       "      <td>1459655831</td>\n",
       "      <td>2012-09-26T00:00:00.001Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.662</td>\n",
       "      <td>-79.340</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1741021722</td>\n",
       "      <td>1357476826</td>\n",
       "      <td>2012-08-31T23:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.983</td>\n",
       "      <td>-79.250</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13388</th>\n",
       "      <td>620931168</td>\n",
       "      <td>3912727517</td>\n",
       "      <td>2012-10-03T21:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13389</th>\n",
       "      <td>2135167144</td>\n",
       "      <td>2847881957</td>\n",
       "      <td>2012-10-21T02:00:00.003Z</td>\n",
       "      <td>Anaheim</td>\n",
       "      <td>CA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.856</td>\n",
       "      <td>-117.863</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13390</th>\n",
       "      <td>4092803548</td>\n",
       "      <td>1818198294</td>\n",
       "      <td>2012-10-27T19:00:00.003Z</td>\n",
       "      <td>Helsinki</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Finland</td>\n",
       "      <td>60.163</td>\n",
       "      <td>24.941</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13391</th>\n",
       "      <td>3851706723</td>\n",
       "      <td>4022520287</td>\n",
       "      <td>2012-10-10T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13392</th>\n",
       "      <td>4283392525</td>\n",
       "      <td>1272638968</td>\n",
       "      <td>2012-10-31T03:00:00.003Z</td>\n",
       "      <td>Albuquerque</td>\n",
       "      <td>NM</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>35.079</td>\n",
       "      <td>-106.599</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13393</th>\n",
       "      <td>3938234624</td>\n",
       "      <td>3155750308</td>\n",
       "      <td>2012-11-30T19:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13394</th>\n",
       "      <td>3696272381</td>\n",
       "      <td>2511987302</td>\n",
       "      <td>2012-11-02T12:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13395</th>\n",
       "      <td>4153011100</td>\n",
       "      <td>902911007</td>\n",
       "      <td>2012-09-23T04:30:00.003Z</td>\n",
       "      <td>Phoenix</td>\n",
       "      <td>AZ</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>33.449</td>\n",
       "      <td>-112.072</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>173</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13396</th>\n",
       "      <td>3616152803</td>\n",
       "      <td>2309901072</td>\n",
       "      <td>2012-11-18T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13397</th>\n",
       "      <td>806696202</td>\n",
       "      <td>2376596313</td>\n",
       "      <td>2012-12-01T19:00:00.003Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>M6G 1M4</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.662</td>\n",
       "      <td>-79.425</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13398</th>\n",
       "      <td>2579139880</td>\n",
       "      <td>3122709116</td>\n",
       "      <td>2012-11-30T14:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.167</td>\n",
       "      <td>101.651</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13399</th>\n",
       "      <td>3483869180</td>\n",
       "      <td>3636323848</td>\n",
       "      <td>2012-11-02T11:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13400</th>\n",
       "      <td>3327512314</td>\n",
       "      <td>337595881</td>\n",
       "      <td>2012-08-11T17:00:00.000Z</td>\n",
       "      <td>Amsterdam</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>52.390</td>\n",
       "      <td>4.825</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13401</th>\n",
       "      <td>3392687713</td>\n",
       "      <td>2942481107</td>\n",
       "      <td>2012-11-22T02:00:00.003Z</td>\n",
       "      <td>San Antonio</td>\n",
       "      <td>TX</td>\n",
       "      <td>78212</td>\n",
       "      <td>United States</td>\n",
       "      <td>29.455</td>\n",
       "      <td>-98.500</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13402</th>\n",
       "      <td>2175249529</td>\n",
       "      <td>2758197166</td>\n",
       "      <td>2012-09-23T02:00:00.003Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.657</td>\n",
       "      <td>-79.403</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13403</th>\n",
       "      <td>376593949</td>\n",
       "      <td>415464198</td>\n",
       "      <td>2012-10-12T00:00:00.002Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13404</th>\n",
       "      <td>3669346949</td>\n",
       "      <td>3414348124</td>\n",
       "      <td>2012-10-07T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13405</th>\n",
       "      <td>2803195749</td>\n",
       "      <td>455278736</td>\n",
       "      <td>2012-10-31T00:00:00.001Z</td>\n",
       "      <td>Banyumas</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Indonesia</td>\n",
       "      <td>-7.444</td>\n",
       "      <td>109.244</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13406</th>\n",
       "      <td>1064284965</td>\n",
       "      <td>275013371</td>\n",
       "      <td>2012-10-24T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-7.284</td>\n",
       "      <td>112.764</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13407</th>\n",
       "      <td>2588804869</td>\n",
       "      <td>3578405258</td>\n",
       "      <td>2012-10-31T19:00:00.003Z</td>\n",
       "      <td>Tirana</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Albania</td>\n",
       "      <td>41.338</td>\n",
       "      <td>19.785</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13408</th>\n",
       "      <td>156353771</td>\n",
       "      <td>2315928166</td>\n",
       "      <td>2012-10-28T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13409</th>\n",
       "      <td>2200684348</td>\n",
       "      <td>1507135490</td>\n",
       "      <td>2012-12-07T03:00:00.003Z</td>\n",
       "      <td>Paterson</td>\n",
       "      <td>NJ</td>\n",
       "      <td>07501-3626</td>\n",
       "      <td>United States</td>\n",
       "      <td>40.909</td>\n",
       "      <td>-74.159</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13410</th>\n",
       "      <td>3720632668</td>\n",
       "      <td>3899589477</td>\n",
       "      <td>2012-11-17T04:30:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.235</td>\n",
       "      <td>-118.473</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13411</th>\n",
       "      <td>423805107</td>\n",
       "      <td>2525044672</td>\n",
       "      <td>2012-10-01T15:00:00.003Z</td>\n",
       "      <td>Granby</td>\n",
       "      <td>QC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>45.402</td>\n",
       "      <td>-72.731</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13412</th>\n",
       "      <td>3822409571</td>\n",
       "      <td>202776250</td>\n",
       "      <td>2012-08-02T19:00:00.000Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.653</td>\n",
       "      <td>-79.401</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13413</th>\n",
       "      <td>1699116640</td>\n",
       "      <td>3032684355</td>\n",
       "      <td>2012-11-21T00:00:00.003Z</td>\n",
       "      <td>Toronto</td>\n",
       "      <td>ON</td>\n",
       "      <td>M6J 1B8</td>\n",
       "      <td>Canada</td>\n",
       "      <td>43.645</td>\n",
       "      <td>-79.417</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13414</th>\n",
       "      <td>2700038507</td>\n",
       "      <td>1437095076</td>\n",
       "      <td>2012-10-31T00:00:00.001Z</td>\n",
       "      <td>Iztapalapa</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>19.442</td>\n",
       "      <td>-99.138</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13415</th>\n",
       "      <td>2522610844</td>\n",
       "      <td>741828421</td>\n",
       "      <td>2012-10-19T01:00:00.003Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>177</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13416</th>\n",
       "      <td>1429241116</td>\n",
       "      <td>4044300809</td>\n",
       "      <td>2012-08-10T02:30:00.000Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19.060</td>\n",
       "      <td>-98.280</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13417</th>\n",
       "      <td>1973916091</td>\n",
       "      <td>2525805561</td>\n",
       "      <td>2012-10-30T00:00:00.001Z</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13418 rows × 110 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         event_id     user_id                start_time           city state  \\\n",
       "0      1845469953  2522958388  2012-08-18T03:00:00.003Z            NaN   NaN   \n",
       "1       715927047  2897297904  2012-09-30T01:00:00.003Z        Oakland    CA   \n",
       "2      1129492416  3585990576  2012-11-23T05:45:00.003Z            NaN   NaN   \n",
       "3      2351559782  3258059419  2012-10-27T00:00:00.001Z            NaN   NaN   \n",
       "4       741936389  3930427944  2012-10-31T10:00:00.003Z         Malang   NaN   \n",
       "5      1948220396  4227306561  2012-11-04T00:00:00.003Z            NaN   NaN   \n",
       "6        34564349  1692956626  2012-08-30T14:00:00.003Z    Mississauga    ON   \n",
       "7      4015174764  4022520287  2012-10-23T00:00:00.001Z            NaN   NaN   \n",
       "8      1946764368  1325201873  2012-11-03T00:00:00.003Z  San Francisco    CA   \n",
       "9      1819998447  2552531914  2012-11-21T04:00:00.003Z            NaN   NaN   \n",
       "10     2826046335   436803290  2012-09-30T00:00:00.001Z        Anaheim    CA   \n",
       "11     3964060639  2338866445  2012-10-30T00:00:00.001Z            NaN   NaN   \n",
       "12     2383453267  1909585056  2012-11-05T05:30:00.003Z         Mumbai   NaN   \n",
       "13     3950353223  3612176534  2012-10-28T00:00:00.001Z            NaN   NaN   \n",
       "14     1824198418  1765760625  2012-11-09T04:00:00.003Z    Los Angeles    CA   \n",
       "15      533036818   212960004  2013-01-27T02:00:00.003Z    Los Angeles    CA   \n",
       "16     3127693636   932476685  2012-09-23T02:00:00.003Z       Oakville    ON   \n",
       "17      326944617  1332974458  2012-11-29T17:49:11.002Z            NaN   NaN   \n",
       "18     1112861675  1424862274  2012-10-30T00:00:00.001Z            NaN   NaN   \n",
       "19     1446660181  3255369878  2012-12-08T17:00:00.003Z        Doswell    VA   \n",
       "20     4234683959  1721067031  2012-10-11T00:00:00.001Z  Niagara Falls    ON   \n",
       "21     2221249291  3912862329  2012-09-29T02:00:00.003Z      Riverdale    GA   \n",
       "22     3022809854  3428829795  2012-08-31T00:00:00.001Z            NaN   NaN   \n",
       "23     1222056986  3293416293  2012-11-15T01:00:00.003Z            NaN   NaN   \n",
       "24     2525317671   215831159  2012-08-08T04:00:00.000Z      Fullerton    CA   \n",
       "25      918116457  4193237938  2012-10-31T00:00:00.001Z            NaN   NaN   \n",
       "26     1672546494  2785723175  2012-11-25T06:00:00.003Z  San Francisco    CA   \n",
       "27     1050017180  2744017856  2012-09-29T15:00:00.003Z            NaN   NaN   \n",
       "28     1286933492  1459655831  2012-09-26T00:00:00.001Z        Toronto    ON   \n",
       "29     1741021722  1357476826  2012-08-31T23:00:00.003Z            NaN   NaN   \n",
       "...           ...         ...                       ...            ...   ...   \n",
       "13388   620931168  3912727517  2012-10-03T21:00:00.003Z            NaN   NaN   \n",
       "13389  2135167144  2847881957  2012-10-21T02:00:00.003Z        Anaheim    CA   \n",
       "13390  4092803548  1818198294  2012-10-27T19:00:00.003Z       Helsinki   NaN   \n",
       "13391  3851706723  4022520287  2012-10-10T00:00:00.001Z            NaN   NaN   \n",
       "13392  4283392525  1272638968  2012-10-31T03:00:00.003Z    Albuquerque    NM   \n",
       "13393  3938234624  3155750308  2012-11-30T19:00:00.003Z            NaN   NaN   \n",
       "13394  3696272381  2511987302  2012-11-02T12:00:00.003Z            NaN   NaN   \n",
       "13395  4153011100   902911007  2012-09-23T04:30:00.003Z        Phoenix    AZ   \n",
       "13396  3616152803  2309901072  2012-11-18T00:00:00.001Z            NaN   NaN   \n",
       "13397   806696202  2376596313  2012-12-01T19:00:00.003Z        Toronto    ON   \n",
       "13398  2579139880  3122709116  2012-11-30T14:00:00.003Z            NaN   NaN   \n",
       "13399  3483869180  3636323848  2012-11-02T11:00:00.003Z            NaN   NaN   \n",
       "13400  3327512314   337595881  2012-08-11T17:00:00.000Z      Amsterdam   NaN   \n",
       "13401  3392687713  2942481107  2012-11-22T02:00:00.003Z    San Antonio    TX   \n",
       "13402  2175249529  2758197166  2012-09-23T02:00:00.003Z        Toronto    ON   \n",
       "13403   376593949   415464198  2012-10-12T00:00:00.002Z            NaN   NaN   \n",
       "13404  3669346949  3414348124  2012-10-07T00:00:00.001Z            NaN   NaN   \n",
       "13405  2803195749   455278736  2012-10-31T00:00:00.001Z       Banyumas   NaN   \n",
       "13406  1064284965   275013371  2012-10-24T00:00:00.001Z            NaN   NaN   \n",
       "13407  2588804869  3578405258  2012-10-31T19:00:00.003Z         Tirana   NaN   \n",
       "13408   156353771  2315928166  2012-10-28T00:00:00.001Z            NaN   NaN   \n",
       "13409  2200684348  1507135490  2012-12-07T03:00:00.003Z       Paterson    NJ   \n",
       "13410  3720632668  3899589477  2012-11-17T04:30:00.003Z            NaN   NaN   \n",
       "13411   423805107  2525044672  2012-10-01T15:00:00.003Z         Granby    QC   \n",
       "13412  3822409571   202776250  2012-08-02T19:00:00.000Z        Toronto    ON   \n",
       "13413  1699116640  3032684355  2012-11-21T00:00:00.003Z        Toronto    ON   \n",
       "13414  2700038507  1437095076  2012-10-31T00:00:00.001Z     Iztapalapa   NaN   \n",
       "13415  2522610844   741828421  2012-10-19T01:00:00.003Z            NaN   NaN   \n",
       "13416  1429241116  4044300809  2012-08-10T02:30:00.000Z            NaN   NaN   \n",
       "13417  1973916091  2525805561  2012-10-30T00:00:00.001Z            NaN   NaN   \n",
       "\n",
       "              zip        country     lat      lng  c_1   ...     c_92  c_93  \\\n",
       "0             NaN            NaN     NaN      NaN    3   ...        0     0   \n",
       "1             NaN  United States  37.752 -122.201   10   ...        0     0   \n",
       "2             NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "3             NaN            NaN     NaN      NaN    1   ...        0     0   \n",
       "4             NaN      Indonesia  -7.983  112.631    0   ...        0     0   \n",
       "5             NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "6             NaN         Canada  43.703  -79.637    5   ...        0     0   \n",
       "7             NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "8             NaN  United States  37.753 -122.411    4   ...        0     0   \n",
       "9             NaN            NaN     NaN      NaN    1   ...        0     0   \n",
       "10            NaN  United States  33.839 -117.915    0   ...        0     0   \n",
       "11            NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "12            NaN          India  18.980   72.820    0   ...        0     0   \n",
       "13            NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "14            NaN  United States  34.008 -118.335   11   ...        0     0   \n",
       "15          90021  United States  34.029 -118.240   16   ...        0     0   \n",
       "16            NaN         Canada  43.488  -79.719    3   ...        0     1   \n",
       "17            NaN            NaN     NaN      NaN    0   ...        0     1   \n",
       "18            NaN            NaN     NaN      NaN    1   ...        0     0   \n",
       "19          23047  United States  37.851  -77.424    4   ...        0     0   \n",
       "20            NaN         Canada  43.092  -79.077    1   ...        0     0   \n",
       "21            NaN  United States  33.553  -84.465    2   ...        0     0   \n",
       "22            NaN            NaN     NaN      NaN    1   ...        0     0   \n",
       "23            NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "24            NaN  United States  33.870 -117.923    4   ...        0     0   \n",
       "25            NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "26          94110  United States  37.756 -122.419    1   ...        0     0   \n",
       "27            NaN            NaN     NaN      NaN    8   ...        0     0   \n",
       "28            NaN         Canada  43.662  -79.340    0   ...        0     0   \n",
       "29            NaN            NaN  42.983  -79.250    0   ...        0     0   \n",
       "...           ...            ...     ...      ...  ...   ...      ...   ...   \n",
       "13388         NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "13389         NaN  United States  33.856 -117.863    2   ...        0     0   \n",
       "13390         NaN        Finland  60.163   24.941    4   ...        0     0   \n",
       "13391         NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "13392         NaN  United States  35.079 -106.599    3   ...        1     0   \n",
       "13393         NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "13394         NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "13395         NaN  United States  33.449 -112.072    1   ...        0     0   \n",
       "13396         NaN            NaN     NaN      NaN    1   ...        0     0   \n",
       "13397     M6G 1M4         Canada  43.662  -79.425    7   ...        0     0   \n",
       "13398         NaN            NaN   3.167  101.651    5   ...        0     0   \n",
       "13399         NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "13400         NaN    Netherlands  52.390    4.825    4   ...        0     0   \n",
       "13401       78212  United States  29.455  -98.500    0   ...        0     0   \n",
       "13402         NaN         Canada  43.657  -79.403    0   ...        0     0   \n",
       "13403         NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "13404         NaN            NaN     NaN      NaN    4   ...        1     0   \n",
       "13405         NaN      Indonesia  -7.444  109.244    0   ...        0     0   \n",
       "13406         NaN            NaN  -7.284  112.764    0   ...        0     0   \n",
       "13407         NaN        Albania  41.338   19.785    0   ...        0     0   \n",
       "13408         NaN            NaN     NaN      NaN    1   ...        0     0   \n",
       "13409  07501-3626  United States  40.909  -74.159    2   ...        0     0   \n",
       "13410         NaN            NaN  34.235 -118.473    2   ...        0     0   \n",
       "13411         NaN         Canada  45.402  -72.731    3   ...        1     0   \n",
       "13412         NaN         Canada  43.653  -79.401    7   ...        1     1   \n",
       "13413     M6J 1B8         Canada  43.645  -79.417    4   ...        0     1   \n",
       "13414         NaN         Mexico  19.442  -99.138    0   ...        0     0   \n",
       "13415         NaN            NaN     NaN      NaN    0   ...        0     0   \n",
       "13416         NaN            NaN  19.060  -98.280    0   ...        0     0   \n",
       "13417         NaN            NaN     NaN      NaN    1   ...        0     1   \n",
       "\n",
       "       c_94  c_95  c_96  c_97  c_98  c_99  c_100  c_other  \n",
       "0         0     1     0     0     0     0      0       54  \n",
       "1         2     0     1     0     0     0      0       86  \n",
       "2         0     0     0     0     0     0      0       35  \n",
       "3         0     0     0     0     0     0      0       13  \n",
       "4         0     0     0     0     0     0      0      253  \n",
       "5         0     0     0     0     0     0      0        5  \n",
       "6         1     1     0     0     0     0      0      128  \n",
       "7         0     0     0     0     0     0      0       14  \n",
       "8         0     0     1     0     0     0      0       52  \n",
       "9         0     0     0     0     0     0      0       17  \n",
       "10        0     0     0     0     0     0      0       42  \n",
       "11        1     0     0     1     0     0      0       48  \n",
       "12        0     0     0     1     0     0      0       16  \n",
       "13        0     0     0     0     0     0      0       96  \n",
       "14        1     0     1     1     4     0      0      304  \n",
       "15        0     0     3     1     0     0      0      336  \n",
       "16        0     0     0     0     0     0      0       51  \n",
       "17        0     0     1     0     0     0      0       27  \n",
       "18        0     0     0     0     0     0      0        9  \n",
       "19        0     0     0     0     0     0      0       57  \n",
       "20        0     0     0     1     0     0      0       39  \n",
       "21        0     0     0     0     0     0      0       54  \n",
       "22        0     0     0     0     0     0      0        9  \n",
       "23        0     0     0     0     0     0      0        9  \n",
       "24        0     0     0     0     0     0      0       63  \n",
       "25        0     0     0     0     0     0      0        2  \n",
       "26        0     0     0     0     0     0      0       28  \n",
       "27        0     0     0     0     0     0      0       67  \n",
       "28        0     0     0     0     0     0      0       21  \n",
       "29        0     0     0     0     0     0      0       10  \n",
       "...     ...   ...   ...   ...   ...   ...    ...      ...  \n",
       "13388     0     0     0     0     0     0      0       15  \n",
       "13389     0     0     0     0     0     1      0       19  \n",
       "13390     0     0     0     0     0     0      0       68  \n",
       "13391     0     0     0     0     0     0      0       14  \n",
       "13392     0     0     0     1     0     0      0       40  \n",
       "13393     0     0     0     0     0     0      0       22  \n",
       "13394     0     0     0     0     0     0      0       10  \n",
       "13395     0     0     0     0     0     1      0      173  \n",
       "13396     0     0     0     0     0     0      0        5  \n",
       "13397     0     0     0     0     0     0      0       96  \n",
       "13398     0     0     0     0     0     0      1       80  \n",
       "13399     0     0     0     0     0     0      0        5  \n",
       "13400     0     0     0     0     0     0      0       33  \n",
       "13401     0     0     0     0     0     0      0       38  \n",
       "13402     0     0     0     0     0     0      0       40  \n",
       "13403     0     0     0     0     0     0      0       10  \n",
       "13404     0     0     0     0     0     0      0       34  \n",
       "13405     0     0     0     0     0     0      0       75  \n",
       "13406     0     0     0     0     0     0      0      125  \n",
       "13407     0     0     0     0     0     0      0       33  \n",
       "13408     0     0     0     0     0     0      0        9  \n",
       "13409     0     0     0     0     0     0      0       60  \n",
       "13410     0     0     0     0     0     0      0       67  \n",
       "13411     0     0     0     0     0     0      0       39  \n",
       "13412     0     0     1     0     2     1      0       60  \n",
       "13413     0     0     0     0     1     0      1       63  \n",
       "13414     0     0     0     0     0     0      0       43  \n",
       "13415     0     0     0     0     0     0      1      177  \n",
       "13416     0     0     0     0     0     0      0       29  \n",
       "13417     0     0     0     0     0     0      0        9  \n",
       "\n",
       "[13418 rows x 110 columns]"
      ]
     },
     "execution_count": 257,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#重置索引\n",
    "con_events=con_events.reset_index(drop=True)\n",
    "con_events"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 259,
   "metadata": {},
   "outputs": [],
   "source": [
    "#保存数据\n",
    "con_events.to_csv(\"con_events.csv\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
